insert overwrite table yl_ods.tab_barscan_sign partition(dt)
select
billcode
,delivertime
,receipttype
,deliveruser
,null as signuser
,signedstatus
,inputuser
,inputtime
,remark
,inputsite
,deliverfee
,freightcollect
,sendstation
,null as destination
,realweight
,cod
,fctomonth
,fccurrency
,deliverfeecurrency
,codcurrency
,codflag
,sendsite
,destsite
,senddate
,recepitsigned
,siteaccountflag
,fcmonthlyaccount
,transferflag
,transfertime
,transferuser
,commision
,inputtype
,modifystatus
,currency
,collecttype
,shifts
,commisionremark
,pcs
,chargedweight
,contractarea
,agentflag
,scansitecode
,uploadtime
,remark3
,scanusercode
,send_deliver_usercode
,nextstationcode
,source
,remark5
,remark6
,remark4
,scansiteid
,nextstationid
,scanuserid
,send_deliver_userid
,dt
from jms_ods.tab_barscan_sign
where dt = '{{ execution_date | cst_ds }}' ;
